package com.cherry.openlib.datebase.origin;

public interface SqlConstant {

    String TABLE_STUDENT = "student";

    String CREATE_TABLE_STUDENT_SQL = "create table " + TABLE_STUDENT + "(" +
            "id integer primary key autoincrement," +
            "name text(20) not null," +
            "gender text(2) default '男' check(gender in ('男','女')))";

    String QUERY_WHERE_NAME = "select * from " + TABLE_STUDENT + " where name = ?";

    String UPDATE_WHERE_NAME = "update " + TABLE_STUDENT + " set gender = \"男\" where name = ?";
}
